﻿CREATE TABLE [dbo].[ExchangeRate] (
    [Id]              UNIQUEIDENTIFIER ROWGUIDCOL NOT NULL,
    [Month]           INT              NOT NULL,
    [Year]            INT              NOT NULL,
    [MainCurrencyId]  UNIQUEIDENTIFIER NOT NULL,
    [LocalCurrencyId] UNIQUEIDENTIFIER NOT NULL,
    [Rate]            FLOAT            NULL
);


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'Main currency to compare with e.g. USD', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'ExchangeRate', @level2type = N'COLUMN', @level2name = N'MainCurrencyId';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'Local currency to get rate for Main currency e.g. how many UGX make up 1 USD', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'ExchangeRate', @level2type = N'COLUMN', @level2name = N'LocalCurrencyId';

